package com.group.EducationalSystem.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.group.EducationalSystem.bean.Course;
import com.group.EducationalSystem.bean.Student;
import com.group.EducationalSystem.bean.StudentScoreMsg;
import com.group.EducationalSystem.bean.TeacherSelfMsg;

@Mapper
public interface TeacherMapper {
	public TeacherSelfMsg getTeacherMsgByNumber(TeacherSelfMsg teacherSelfMsg);
	public int updateTeacherInfoById(TeacherSelfMsg teacherSelfMsg);
	public Course [] getClassMsgByTeacherId(int teacher_id);
	public Student [] getStudentByCollegeId(int college_id);
	public void addCourse(Course course);
	public void deleteCourseById(@Param("course_id")int course_id);
	public void updateCourse(Course c);
	public StudentScoreMsg [] getStudentScoreByCollegeId(@Param("college_idd") int collegeid);
}
